Download Database Fundamentals.98-364.BrainDumps.2018-11-13.78q.vcex

Vendor: Microsoft
Exam Code: 98-364
Exam Name: Database Fundamentals
Date: Nov 13, 2018
File Size: 855 KB

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

ProfExam Discount

Demo Questions

Question 1
You have the following table definition:
CREATE  TABLE  Road 
      (RoadID     INTEGER  NOT  NULL,  
       Distance    INTEGER  NOT  NULL) 
The Road table contains the following data:
  
You execute the following statement: 
INSERT  INTO  Road VALUES   (1234, 36) 
What is the result?
  1. an error stating that NULL values are not allowed
  2. a new row in the table
  3. an error stating that duplicate IDs are not allowed
  4. a syntax error
Correct answer: B
Question 2
You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used. 
Which data type should you use?
  1. VARCHAR (3, 30)
  2. CHAR (3, 30)
  3. VARCHAR (30)
  4. CHAR (30)
Correct answer: C
Question 3
One reason to create a stored procedure is to:
  1. Improve performance.
  2. Minimize storage space.
  3. Bypass case sensitivity requirements.
  4. Give the user control of the query logic.
Correct answer: A
Question 4
Which permission does a user need in order to run a stored procedure?
  1. EXECUTE
  2. ALLOW
  3. CALL
  4. RUN
Correct answer: A
Question 5
You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category. 
You execute a statement on the Product table that deletes all the products in the Furniture category.  
After you execute the statement, the result set of the view is:
  1. Empty
  2. Deleted
  3. Unchanged
  4. Archived
Correct answer: A
Question 6
In SQL, an insert statement is used to add a:
  1. User to a database.
  2. Row of data to a table.
  3. Table to a database.
  4. Column to a table definition.
Correct answer: B
Question 7
You have two tables. Each table has three rows. 
How many rows will be included in the Cartesian product of these two tables?
  1. 0
  2. 3
  3. 6
  4. 9
Correct answer: D
Question 8
You are writing an SQL statement to retrieve rows from a table.  
Which data manipulation language (DML) command should you use?
  1. READ
  2. SELECT
  3. OUTPUT
  4. GET
Correct answer: B
Question 9
Which constraint ensures a unique value in the ID column for each customer?
  1. DISTINCT
  2. FOREIGN KEY
  3. SEQUENTIAL
  4. PRIMARY KEY
Correct answer: D
Question 10
The component that holds information for a single entry in a table is called a:
  1. Data type
  2. Row
  3. Column
  4. View
Correct answer: B
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!